﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using CRM.UTIL;

namespace CRM.DAL.Ali
{
    public class Ali_OrdersD : DBChannel
    {
        /// <summary>
        /// 可以在此选择数据库连接，默认为CRM
        /// </summary>
        public Ali_OrdersD() : base() { }


        #region 执行存储过程 Pro_GetAli_Orders 
        /// <summary>
        /// 执行存储过程 Pro_GetAli_Orders 
        ///xialei
        /// </summary>

        public DataTable ExecuteGetAli_Orders(ref CRM.MODEL.Ali.GetAli_Orders stu)
{	
	//存储过程参数	 		     
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.IDPARM,SqlDbType.Int));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERIDPARM,SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.BizIDPARM, SqlDbType.BigInt));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ENIDPARM, SqlDbType.BigInt));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.RUIDPARM, SqlDbType.BigInt));
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERDATEPARM,SqlDbType.DateTime));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.BRANDNAMEPARM, SqlDbType.VarChar,100));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTMODELPARM, SqlDbType.VarChar,100));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ITEMCONDITIONPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.RAMPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ROMPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.DISPLAYSIZEPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.DISPLAYRESOLUTIONPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.BATTERYCAPACITYPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.CPUPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SIZEPARM, SqlDbType.VarChar, 100));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.OPERATIONSYSTEMPARM, SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.OSPARM, SqlDbType.VarChar, 50));
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTIMEIPARM,SqlDbType.VarChar));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTSNPARM,SqlDbType.VarChar));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTNAMEPARM,SqlDbType.VarChar,100));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTSKUINFOPARM,SqlDbType.VarChar,100));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTSNAPSHOTURLPARM,SqlDbType.VarChar,500));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTPROPERTIESPARM,
                SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.BUYERALIIDPARM,
        SqlDbType.VarChar, 50));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERALIIDPARM,
        SqlDbType.VarChar, 50));
            this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERCOUNTRYPARM,
                SqlDbType.VarChar, 100));
            this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERPROVINCEPARM,
                SqlDbType.VarChar, 100));
            this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERNAMEPARM,
                SqlDbType.VarChar, 50));
            this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLEREMAILPARM,
                SqlDbType.VarChar, 50));
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.STOREURLPARM,SqlDbType.VarChar,500));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.TELEPHONEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.NAMEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.COUNTRYPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PROVINCEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.CITYPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.COUNTYPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.STREETADDRESSPARM,SqlDbType.VarChar,100));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.POSTCODEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SENDGOODSTIMEPARM,SqlDbType.DateTime));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERIDGETGOODSTIMEPARM,SqlDbType.DateTime));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SELLERFAMILYNAMEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.DESCRIPTIONPARM,SqlDbType.VarChar,200));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ATTACHMENTSPARM,SqlDbType.VarChar));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMEPARM,SqlDbType.DateTime));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMEPARM,SqlDbType.DateTime));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTCOUNTPARM,SqlDbType.Int));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.WARRANTYSTATUSPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.WARRANTYTYPEPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.STATUSPARM,SqlDbType.VarChar,50));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTAMOUNTPARM,SqlDbType.Decimal));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICEAMOUNTPARM,SqlDbType.Decimal));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PAYCURRENCYPARM,SqlDbType.VarChar,10));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERCURRENCYPARM,SqlDbType.VarChar,10));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.EXCHANGEPARM,SqlDbType.Decimal));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SUPPLIERIDPARM,SqlDbType.Int));	
	this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.CUSTSERVICEIDPARM,SqlDbType.Int));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEPARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATEPARM, SqlDbType.DateTime));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PRODUCTTYPEPARM, SqlDbType.VarChar,20));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERFROMTYPEPARM, SqlDbType.Int));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.REMARKPARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ENTERSYSTIMEPARM, SqlDbType.DateTime));
	
    //分页参数
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERSTRING_PARM, SqlDbType.VarChar, 1000));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.PAGESIZE_PARM, SqlDbType.Int));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.CURRENTPAGEINDEX_PARM, SqlDbType.Int));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.TOTALITEMS_PARM, SqlDbType.Decimal));

    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.KEY_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERDATESTART_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.ORDERDATEEND_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMESTART_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMEEND_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMESTART_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMEEND_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATESTART_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATEEND_PARM, SqlDbType.VarChar));
    this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.GetAli_Orders.HASISSUEPARM, SqlDbType.VarChar));
    
     //设置参数的值
     this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.IDPARM].Value = stu.IDVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERIDPARM].Value = stu.ORDERIDVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.BizIDPARM].Value = stu.BizIDVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ENIDPARM].Value = stu.ENIDVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.RUIDPARM].Value = stu.RUIDVALUE;       
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERDATEPARM].Value = stu.ORDERDATEVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.BRANDNAMEPARM].Value = stu.BRANDNAMEVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTMODELPARM].Value = stu.PRODUCTMODELVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ITEMCONDITIONPARM].Value = stu.ITEMCONDITIONVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.RAMPARM].Value = stu.RAMVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ROMPARM].Value = stu.ROMVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.DISPLAYSIZEPARM].Value = stu.DISPLAYSIZEVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.DISPLAYRESOLUTIONPARM].Value = stu.DISPLAYRESOLUTIONVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.BATTERYCAPACITYPARM].Value = stu.BATTERYCAPACITYVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.CPUPARM].Value = stu.CPUVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SIZEPARM].Value = stu.SIZEVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.OPERATIONSYSTEMPARM].Value = stu.OPERATIONSYSTEMVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.OSPARM].Value = stu.OSVALUE;  
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTIMEIPARM].Value = stu.PRODUCTIMEIVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTSNPARM].Value = stu.PRODUCTSNVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTNAMEPARM].Value = stu.PRODUCTNAMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTSKUINFOPARM].Value = stu.PRODUCTSKUINFOVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTSNAPSHOTURLPARM].Value = stu.PRODUCTSNAPSHOTURLVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTPROPERTIESPARM].Value = stu.PRODUCTPROPERTIES_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.BUYERALIIDPARM].Value = stu.BUYERALIID_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERALIIDPARM].Value = stu.SELLERALIID_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERCOUNTRYPARM].Value = stu.SELLERCOUNTRY_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERPROVINCEPARM].Value = stu.SELLERPROVINCE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERNAMEPARM].Value = stu.SELLERNAME_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLEREMAILPARM].Value = stu.SELLEREMAIL_VALUE;  
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.STOREURLPARM].Value = stu.STOREURLVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.TELEPHONEPARM].Value = stu.TELEPHONEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.NAMEPARM].Value = stu.NAMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.COUNTRYPARM].Value = stu.COUNTRYVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PROVINCEPARM].Value = stu.PROVINCEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.CITYPARM].Value = stu.CITYVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.COUNTYPARM].Value = stu.COUNTYVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.STREETADDRESSPARM].Value = stu.STREETADDRESSVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.POSTCODEPARM].Value = stu.POSTCODEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SENDGOODSTIMEPARM].Value = stu.SENDGOODSTIMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERIDGETGOODSTIMEPARM].Value = stu.SELLERIDGETGOODSTIMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SELLERFAMILYNAMEPARM].Value = stu.SELLERFAMILYNAMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.DESCRIPTIONPARM].Value = stu.DESCRIPTIONVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ATTACHMENTSPARM].Value = stu.ATTACHMENTSVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMEPARM].Value = stu.SERVICESTARTTIMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMEPARM].Value = stu.SERVICEENDTIMEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTCOUNTPARM].Value = stu.PRODUCTCOUNTVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.WARRANTYSTATUSPARM].Value = stu.WARRANTYSTATUSVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.WARRANTYTYPEPARM].Value = stu.WARRANTYTYPEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.STATUSPARM].Value = stu.STATUSVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTAMOUNTPARM].Value = stu.PRODUCTAMOUNTVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICEAMOUNTPARM].Value = stu.SERVICEAMOUNTVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PAYCURRENCYPARM].Value = stu.PAYCURRENCYVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERCURRENCYPARM].Value = stu.ORDERCURRENCYVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.EXCHANGEPARM].Value = stu.EXCHANGEVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SUPPLIERIDPARM].Value = stu.SUPPLIERIDVALUE;            
	this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.CUSTSERVICEIDPARM].Value = stu.CUSTSERVICEIDVALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEPARM].Value = stu.EFFECTIVE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATEPARM].Value = stu.EFFECTIVEDATE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PRODUCTTYPEPARM].Value = stu.PRODUCTTYPE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERFROMTYPEPARM].Value = stu.ORDERFROMTYPE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.REMARKPARM].Value = stu.REMARK_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ENTERSYSTIMEPARM].Value = stu.ENTERSYSTIME_VALUE;
	
	 //设置分页参数的值
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERSTRING_PARM].Value = stu.ORDERSTRING_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.PAGESIZE_PARM].Value = stu.PAGESIZE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.CURRENTPAGEINDEX_PARM].Value = stu.CURRENTPAGEINDEX_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.TOTALITEMS_PARM].Value = stu.TOTALITEMS_VALUE;

    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.KEY_PARM].Value = stu.KEYVALUE_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERDATESTART_PARM].Value = stu.ORDERDATESTART_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.ORDERDATEEND_PARM].Value = stu.ORDERDATEEND_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMESTART_PARM].Value = stu.SERVICESTARTTIMESTART_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICESTARTTIMEEND_PARM].Value = stu.SERVICESTARTTIMEEND_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMESTART_PARM].Value = stu.SERVICEENDTIMESTART_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.SERVICEENDTIMEEND_PARM].Value = stu.SERVICEENDTIMEEND_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATESTART_PARM].Value = stu.EFFECTIVEDATESTART_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.EFFECTIVEDATEEND_PARM].Value = stu.EFFECTIVEDATEEND_VALUE;
    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.HASISSUEPARM].Value = stu.HASISSUE_VALUE;

    this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.TOTALITEMS_PARM].Direction = ParameterDirection.Output;

	//执行
    DataTable dt = this.GetDataByProcedure("dbo.Pro_GetAli_Orders");	
	//获取数据库的信息
	stu.TOTALITEMS_VALUE = this.sqlCmd.Parameters[CRM.MODEL.Ali.GetAli_Orders.TOTALITEMS_PARM].Value;
	
	return dt;
}
        #endregion


        #region 执行存储过程 Pro_EditAli_Orders

        /// <summary>
        /// 执行存储过程 Pro_EditAli_Orders 的相关参数
        ///xialei
        /// </summary>
        public int ExecuteEditAli_Orders(ref CRM.MODEL.Ali.EditAli_Orders stu)
        {


            if ((string) stu.ACTION_VALUE == "Update")
            {
                #region Update

                var sqlSb = new StringBuilder();
                sqlCmd.Parameters.Clear();
                sqlSb.Append(" UPDATE Ali_Orders SET ");

                if (stu.ORDERID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" OrderId=@OrderId,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OrderId", stu.ORDERID_VALUE));
                }
                if (stu.BizID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" BizID=@BizID,");
                    sqlCmd.Parameters.Add(new SqlParameter("@BizID", stu.BizID_VALUE));
                }
                if (stu.ENIDVALUE != DBNull.Value)
                {
                    sqlSb.Append(" ENid=@ENid,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ENid", stu.ENIDVALUE));
                }
                if (stu.RUIDVALUE != DBNull.Value)
                {
                    sqlSb.Append(" RUid=@RUid,");
                    sqlCmd.Parameters.Add(new SqlParameter("@RUid", stu.RUIDVALUE));
                }
                if (stu.ORDERDATE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" OrderDate=@OrderDate,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OrderDate", stu.ORDERDATE_VALUE));
                }
                if (stu.BRANDNAMEVALUE != DBNull.Value)
                {
                    sqlSb.Append(" BrandName=@BrandName,");
                    sqlCmd.Parameters.Add(new SqlParameter("@BrandName", stu.BRANDNAMEVALUE));
                }
                if (stu.PRODUCTMODELVALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductModel=@ProductModel,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductModel", stu.PRODUCTMODELVALUE));
                }
                if (stu.ITEMCONDITIONVALUE != DBNull.Value)
                {
                    sqlSb.Append(" ItemCondition=@ItemCondition,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ItemCondition", stu.ITEMCONDITIONVALUE));
                }
                if (stu.RAMVALUE != DBNull.Value)
                {
                    sqlSb.Append(" RAM=@RAM,");
                    sqlCmd.Parameters.Add(new SqlParameter("@RAM", stu.RAMVALUE));
                }
                if (stu.ROMVALUE != DBNull.Value)
                {
                    sqlSb.Append(" ROM=@ROM,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ROM", stu.ROMVALUE));
                }
                if (stu.DISPLAYSIZEVALUE != DBNull.Value)
                {
                    sqlSb.Append(" DisplaySize=@DisplaySize,");
                    sqlCmd.Parameters.Add(new SqlParameter("@DisplaySize", stu.DISPLAYSIZEVALUE));
                }
                if (stu.DISPLAYRESOLUTIONVALUE != DBNull.Value)
                {
                    sqlSb.Append(" DisplayResolution=@DisplayResolution,");
                    sqlCmd.Parameters.Add(new SqlParameter("@DisplayResolution", stu.DISPLAYRESOLUTIONVALUE));
                }
                if (stu.BATTERYCAPACITYVALUE != DBNull.Value)
                {
                    sqlSb.Append(" BatteryCapacity=@BatteryCapacity,");
                    sqlCmd.Parameters.Add(new SqlParameter("@BatteryCapacity", stu.BATTERYCAPACITYVALUE));
                }
                if (stu.CPUVALUE != DBNull.Value)
                {
                    sqlSb.Append(" CPU=@CPU,");
                    sqlCmd.Parameters.Add(new SqlParameter("@CPU", stu.CPUVALUE));
                }
                if (stu.SIZEVALUE != DBNull.Value)
                {
                    sqlSb.Append(" Size=@Size,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Size", stu.SIZEVALUE));
                }
                if (stu.OPERATIONSYSTEMVALUE != DBNull.Value)
                {
                    sqlSb.Append(" OperationSystem=@OperationSystem,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OperationSystem", stu.OPERATIONSYSTEMVALUE));
                }
                if (stu.OSVALUE != DBNull.Value)
                {
                    sqlSb.Append(" OS=@OS,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OS", stu.OSVALUE));
                }
                if (stu.PRODUCTIMEI_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductIMEI=@ProductIMEI,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductIMEI", stu.PRODUCTIMEI_VALUE.ToString()));
                }
                if (stu.PRODUCTSN_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductSN=@ProductSN,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductSN"
                        , stu.PRODUCTSN_VALUE.ToString()));
                }
                if (stu.PRODUCTNAME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductName=@ProductName,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductName", stu.PRODUCTNAME_VALUE));
                }
                if (stu.PRODUCTSKUINFO_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductSkuInfo=@ProductSkuInfo,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductSkuInfo", stu.PRODUCTSKUINFO_VALUE));
                }
                if (stu.PRODUCTSNAPSHOTURL_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductSnapshotUrl=@ProductSnapshotUrl,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductSnapshotUrl", stu.PRODUCTSNAPSHOTURL_VALUE));
                }
                if (stu.PRODUCTPROPERTIES_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductProperties=@ProductProperties,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductProperties", stu.PRODUCTPROPERTIES_VALUE.ToString()));
                }
                if (stu.BUYERALIID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" BuyerAliId=@BuyerAliId,");
                    sqlCmd.Parameters.Add(new SqlParameter("@BuyerAliId", stu.BUYERALIID_VALUE.ToString()));
                }
                if (stu.SELLERALIID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerAliId=@SellerAliId,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerAliId", stu.SELLERALIID_VALUE.ToString()));
                }
                if (stu.SELLERCOUNTRY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerCountry=@SellerCountry,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerCountry", stu.SELLERCOUNTRY_VALUE));
                }
                if (stu.SELLERPROVINCE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerProvince=@SellerProvince,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerProvince", stu.SELLERPROVINCE_VALUE));
                }
                if (stu.SELLERNAME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerName=@SellerName,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerName", stu.SELLERNAME_VALUE));
                }
                if (stu.SELLEREMAIL_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerEmail=@SellerEmail,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerEmail", stu.SELLEREMAIL_VALUE));
                }
                if (stu.STOREURL_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" StoreUrl=@StoreUrl,");
                    sqlCmd.Parameters.Add(new SqlParameter("@StoreUrl", stu.STOREURL_VALUE));
                }
                if (stu.TELEPHONE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Telephone=@Telephone,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Telephone", stu.TELEPHONE_VALUE));
                }
                if (stu.NAME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Name=@Name,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Name", stu.NAME_VALUE));
                }
                if (stu.COUNTRY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Country=@Country,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Country", stu.COUNTRY_VALUE));
                }
                if (stu.PROVINCE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Province=@Province,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Province", stu.PROVINCE_VALUE));
                }
                if (stu.CITY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" City=@City,");
                    sqlCmd.Parameters.Add(new SqlParameter("@City", stu.CITY_VALUE));
                }
                if (stu.COUNTY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" County=@County,");
                    sqlCmd.Parameters.Add(new SqlParameter("@County", stu.COUNTY_VALUE));
                }
                if (stu.STREETADDRESS_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" StreetAddress=@StreetAddress,");
                    sqlCmd.Parameters.Add(new SqlParameter("@StreetAddress", stu.STREETADDRESS_VALUE));
                }
                if (stu.POSTCODE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" PostCode=@PostCode,");
                    sqlCmd.Parameters.Add(new SqlParameter("@PostCode", stu.POSTCODE_VALUE));
                }
                if (stu.SENDGOODSTIME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SendGoodsTime=@SendGoodsTime,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SendGoodsTime", stu.SENDGOODSTIME_VALUE));
                }
                if (stu.SELLERIDGETGOODSTIME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerIDGetGoodsTime=@SellerIDGetGoodsTime,");
                    sqlCmd.Parameters.Add(new SqlParameter(MODEL.Ali.EditAli_Orders.SELLERIDGETGOODSTIMEPARM,
                        stu.SELLERIDGETGOODSTIME_VALUE));
                }
                if (stu.SELLERFAMILYNAME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SellerFamilyName=@SellerFamilyName,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SellerFamilyName", stu.SELLERFAMILYNAME_VALUE));
                }
                if (stu.DESCRIPTION_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Description=@Description,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Description", stu.DESCRIPTION_VALUE.ToString()));
                }
                if (stu.ATTACHMENTS_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Attachments=@Attachments,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Attachments", stu.ATTACHMENTS_VALUE.ToString()));
                }
                if (stu.SERVICESTARTTIME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ServiceStartTime=@ServiceStartTime,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ServiceStartTime", stu.SERVICESTARTTIME_VALUE));
                }
                if (stu.SERVICEENDTIME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ServiceEndTime=@ServiceEndTime,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ServiceEndTime", stu.SERVICEENDTIME_VALUE));
                }
                if (stu.PRODUCTCOUNT_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductCount=@ProductCount,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductCount", stu.PRODUCTCOUNT_VALUE));
                }
                if (stu.WARRANTYSTATUS_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" WarrantyStatus=@WarrantyStatus,");
                    sqlCmd.Parameters.Add(new SqlParameter("@WarrantyStatus", stu.WARRANTYSTATUS_VALUE));
                }
                if (stu.WARRANTYTYPE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" WarrantyType=@WarrantyType,");
                    sqlCmd.Parameters.Add(new SqlParameter("@WarrantyType", stu.WARRANTYTYPE_VALUE));
                }
                if (stu.STATUS_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Status=@Status,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Status", stu.STATUS_VALUE));
                }
                if (stu.PRODUCTAMOUNT_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductAmount=@ProductAmount,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductAmount", stu.PRODUCTAMOUNT_VALUE));
                }
                if (stu.SERVICEAMOUNT_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ServiceAmount=@ServiceAmount,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ServiceAmount", stu.SERVICEAMOUNT_VALUE));
                }
                if (stu.PAYCURRENCY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" PayCurrency=@PayCurrency,");
                    sqlCmd.Parameters.Add(new SqlParameter("@PayCurrency", stu.PAYCURRENCY_VALUE));
                }
                if (stu.ORDERCURRENCY_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" OrderCurrency=@OrderCurrency,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OrderCurrency", stu.ORDERCURRENCY_VALUE));
                }
                if (stu.EXCHANGE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Exchange=@Exchange,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Exchange", stu.EXCHANGE_VALUE));
                }
                if (stu.SUPPLIERID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" SupplierID=@SupplierID,");
                    sqlCmd.Parameters.Add(new SqlParameter("@SupplierID", stu.SUPPLIERID_VALUE));
                }
                if (stu.CUSTSERVICEID_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" CustServiceID=@CustServiceID,");
                    sqlCmd.Parameters.Add(new SqlParameter("@CustServiceID", stu.CUSTSERVICEID_VALUE));
                }
                if (stu.EFFECTIVE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Effective=@Effective,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Effective", stu.EFFECTIVE_VALUE));
                }
                if (stu.EFFECTIVEDATE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" EffectiveDate=@EffectiveDate,");
                    sqlCmd.Parameters.Add(new SqlParameter("@EffectiveDate", stu.EFFECTIVEDATE_VALUE));
                }
                if (stu.PRODUCTTYPE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" ProductType=@ProductType,");
                    sqlCmd.Parameters.Add(new SqlParameter("@ProductType", stu.PRODUCTTYPE_VALUE));
                }
                if (stu.ORDERFROMTYPE_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" OrderFromType=@OrderFromType,");
                    sqlCmd.Parameters.Add(new SqlParameter("@OrderFromType", stu.ORDERFROMTYPE_VALUE));
                }
                if (stu.REMARK_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Remark=@Remark,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Remark", stu.REMARK_VALUE));
                }
                if (stu.ENTERSYSTIME_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" EnterSysTime=@EnterSysTime,");
                    sqlCmd.Parameters.Add(new SqlParameter("@EnterSysTime", stu.ENTERSYSTIME_VALUE));
                }
                if (stu.EMAIL_VALUE != DBNull.Value)
                {
                    sqlSb.Append(" Email=@Email,");
                    sqlCmd.Parameters.Add(new SqlParameter("@Email", stu.EMAIL_VALUE));
                }
                var sql = sqlSb.ToString().TrimEnd(',');

                sqlCmd.Parameters.Add(new SqlParameter("@ID", stu.ID_VALUE));
                //sqlCmd.CommandText = sqlSb.ToString();
                //sqlCmd.ExecuteNonQuery();
                int i = base.ExecuteSQL(sql + " WHERE ID=@ID");

                return i;

                #endregion
            }
            else
            {

                //动作参数
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ACTION_PARM, SqlDbType.VarChar,
                    20));
                //错误信息参数
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ERRMSG_PARM, SqlDbType.VarChar,
                    100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.OUTID_PARM, SqlDbType.Int));
                ////表字段参数
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.IDPARM, SqlDbType.Int));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ORDERIDPARM, SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.BizIDPARM, SqlDbType.BigInt));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ENIDPARM, SqlDbType.BigInt));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.RUIDPARM, SqlDbType.BigInt));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ORDERDATEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.BRANDNAMEPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTMODELPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ITEMCONDITIONPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.RAMPARM, SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ROMPARM, SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.DISPLAYSIZEPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.DISPLAYRESOLUTIONPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.BATTERYCAPACITYPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.CPUPARM, SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SIZEPARM, SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.OPERATIONSYSTEMPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.OSPARM, SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTIMEIPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTSNPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTNAMEPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTSKUINFOPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTSNAPSHOTURLPARM,
                    SqlDbType.VarChar, 500));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTPROPERTIESPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.BUYERALIIDPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERALIIDPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERCOUNTRYPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERPROVINCEPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERNAMEPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLEREMAILPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.STOREURLPARM, SqlDbType.VarChar,
                    500));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.TELEPHONEPARM,
                    SqlDbType.VarChar, 15));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.NAMEPARM, SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.COUNTRYPARM, SqlDbType.VarChar,
                    50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PROVINCEPARM, SqlDbType.VarChar,
                    50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.CITYPARM, SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.COUNTYPARM, SqlDbType.VarChar,
                    50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.STREETADDRESSPARM,
                    SqlDbType.VarChar, 100));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.POSTCODEPARM, SqlDbType.VarChar,
                    50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SENDGOODSTIMEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERIDGETGOODSTIMEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SELLERFAMILYNAMEPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.DESCRIPTIONPARM,
                    SqlDbType.VarChar, 200));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ATTACHMENTSPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SERVICESTARTTIMEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SERVICEENDTIMEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTCOUNTPARM, SqlDbType.Int));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.WARRANTYSTATUSPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.WARRANTYTYPEPARM,
                    SqlDbType.VarChar, 50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.STATUSPARM, SqlDbType.VarChar,
                    50));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTAMOUNTPARM,
                    SqlDbType.Decimal));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SERVICEAMOUNTPARM,
                    SqlDbType.Decimal));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PAYCURRENCYPARM,
                    SqlDbType.VarChar, 10));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ORDERCURRENCYPARM,
                    SqlDbType.VarChar, 10));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.EXCHANGEPARM, SqlDbType.Decimal));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.SUPPLIERIDPARM, SqlDbType.Int));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.CUSTSERVICEIDPARM,
                    SqlDbType.Int));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.EFFECTIVEPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.EFFECTIVEDATEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.PRODUCTTYPEPARM,
                    SqlDbType.VarChar, 20));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ORDERFROMTYPEPARM,
                    SqlDbType.Int));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.REMARKPARM,
                    SqlDbType.VarChar));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.ENTERSYSTIMEPARM,
                    SqlDbType.DateTime));
                this.sqlCmd.Parameters.Add(new SqlParameter(CRM.MODEL.Ali.EditAli_Orders.EMAILPARM,
                    SqlDbType.VarChar));



                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ACTION_PARM].Value = stu.ACTION_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ERRMSG_PARM].Direction = ParameterDirection.Output;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.OUTID_PARM].Direction = ParameterDirection.Output;
                //设置参数的值
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.IDPARM].Value = stu.ID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ORDERIDPARM].Value = stu.ORDERID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.BizIDPARM].Value = stu.BizID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ENIDPARM].Value = stu.ENIDVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.RUIDPARM].Value = stu.RUIDVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ORDERDATEPARM].Value = stu.ORDERDATE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.BRANDNAMEPARM].Value = stu.BRANDNAMEVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTMODELPARM].Value = stu.PRODUCTMODELVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ITEMCONDITIONPARM].Value = stu.ITEMCONDITIONVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.RAMPARM].Value = stu.RAMVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ROMPARM].Value = stu.ROMVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.DISPLAYSIZEPARM].Value = stu.DISPLAYSIZEVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.DISPLAYRESOLUTIONPARM].Value =
                    stu.DISPLAYRESOLUTIONVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.BATTERYCAPACITYPARM].Value =
                    stu.BATTERYCAPACITYVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.CPUPARM].Value = stu.CPUVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SIZEPARM].Value = stu.SIZEVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.OPERATIONSYSTEMPARM].Value =
                    stu.OPERATIONSYSTEMVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.OSPARM].Value = stu.OSVALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTIMEIPARM].Value = stu.PRODUCTIMEI_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTSNPARM].Value = stu.PRODUCTSN_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTNAMEPARM].Value = stu.PRODUCTNAME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTSKUINFOPARM].Value = stu.PRODUCTSKUINFO_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTSNAPSHOTURLPARM].Value =
                    stu.PRODUCTSNAPSHOTURL_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTPROPERTIESPARM].Value =
                    stu.PRODUCTPROPERTIES_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.BUYERALIIDPARM].Value =
                    stu.BUYERALIID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERALIIDPARM].Value =
                    stu.SELLERALIID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERCOUNTRYPARM].Value = stu.SELLERCOUNTRY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERPROVINCEPARM].Value = stu.SELLERPROVINCE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERNAMEPARM].Value = stu.SELLERNAME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLEREMAILPARM].Value = stu.SELLEREMAIL_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.STOREURLPARM].Value = stu.STOREURL_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.TELEPHONEPARM].Value = stu.TELEPHONE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.NAMEPARM].Value = stu.NAME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.COUNTRYPARM].Value = stu.COUNTRY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PROVINCEPARM].Value = stu.PROVINCE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.CITYPARM].Value = stu.CITY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.COUNTYPARM].Value = stu.COUNTY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.STREETADDRESSPARM].Value = stu.STREETADDRESS_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.POSTCODEPARM].Value = stu.POSTCODE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SENDGOODSTIMEPARM].Value = stu.SENDGOODSTIME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERIDGETGOODSTIMEPARM].Value =
                    stu.SELLERIDGETGOODSTIME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SELLERFAMILYNAMEPARM].Value =
                    stu.SELLERFAMILYNAME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.DESCRIPTIONPARM].Value = stu.DESCRIPTION_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ATTACHMENTSPARM].Value = stu.ATTACHMENTS_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SERVICESTARTTIMEPARM].Value =
                    stu.SERVICESTARTTIME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SERVICEENDTIMEPARM].Value = stu.SERVICEENDTIME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTCOUNTPARM].Value = stu.PRODUCTCOUNT_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.WARRANTYSTATUSPARM].Value = stu.WARRANTYSTATUS_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.WARRANTYTYPEPARM].Value = stu.WARRANTYTYPE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.STATUSPARM].Value = stu.STATUS_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTAMOUNTPARM].Value = stu.PRODUCTAMOUNT_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SERVICEAMOUNTPARM].Value = stu.SERVICEAMOUNT_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PAYCURRENCYPARM].Value = stu.PAYCURRENCY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ORDERCURRENCYPARM].Value = stu.ORDERCURRENCY_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.EXCHANGEPARM].Value = stu.EXCHANGE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.SUPPLIERIDPARM].Value = stu.SUPPLIERID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.CUSTSERVICEIDPARM].Value = stu.CUSTSERVICEID_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.EFFECTIVEPARM].Value = stu.EFFECTIVE_VALUE ?? false;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.EFFECTIVEDATEPARM].Value = stu.EFFECTIVEDATE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.PRODUCTTYPEPARM].Value = stu.PRODUCTTYPE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ORDERFROMTYPEPARM].Value = stu.ORDERFROMTYPE_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.REMARKPARM].Value = stu.REMARK_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ENTERSYSTIMEPARM].Value = stu.ENTERSYSTIME_VALUE;
                this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.EMAILPARM].Value = stu.EMAIL_VALUE;

                int i = this.ExecuteProcedure("dbo.Pro_EditAli_Orders"); //执行	
                //获取数据库的信息
                stu.ERRMSG_VALUE = this.sqlCmd.Parameters[CRM.MODEL.Ali.EditAli_Orders.ERRMSG_PARM].Value;
                return i;
            }
        }

        #endregion
    }
}
